From 6279986f5f77cab69d19733925f173eadca23b60 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Sun, 19 Jul 2026 14:17:13 -0700 Subject: [PATCH] harden commit 8a528cc7d1a9fb solution to problem #19 --- conversion/load_biography_update_log.sql | 11 ++++------- 1 file changed, 4 insertions(+), 7 deletions(-) diff --git a/conversion/load_biography_update_log.sql b/conversion/load_biography_update_log.sql index 44c5a4e..e0acdba 100644 --- a/conversion/load_biography_update_log.sql +++ b/conversion/load_biography_update_log.sql @@ -32,13 +32,10 @@ INSERT INTO biography_log ( , chimp_id , update_description , update_rationale - , CASE -- This solves NULL data problems; problem #19 - WHEN made_by IS NULL - THEN 'UNK' - ELSE made_by - END CASE - FROM biography_update_log as log + -- Map missing values to the unknown person; problem #19 + , COALESCE(NULLIF(BTRIM(log.made_by), ''), 'UNK') + FROM biography_update_log AS log -- Get a consistent id generation - ORDER BY date_of_update, chimp_id, update_rationale, made_by; + ORDER BY date_of_update, chimp_id, update_rationale, log.made_by; ANALYZE biography_log; -- 2.34.1